package io.renren.dao;

import io.renren.common.dao.BaseDao;
import io.renren.entity.WxsendmbillEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * ${comments}
 *
 * @author Sen 524227263@qq.com
 * @since 1.0.0 2024-06-11
 */
@Mapper
public interface WxsendmbillDao extends BaseDao<WxsendmbillEntity> {

    @Select("SELECT * FROM WxSendMBill WHERE TraderMOID =#{userId}  and Groupid =#{groupId} AND Type =#{type} ORDER BY SYS_Created DESC ")
    List<WxsendmbillEntity> getLasterSendStatus(@Param("userId") String userId, @Param("type") Integer type, @Param("groupId") String groupId);
}